Excel Economic - Functions
By Class in conjunction with secondary element CapClass1, CapClass2… or OpcostClass1, OpcostClass2… or Class Name i.e. Development
By Product detailed in conjunction with secondary elements Gas, C1, C2, Oil…
Revenue
Gross Revenue: "TOTALREVENUE", "TOTALGROSSREVENUE"
WI Revenue: "TOTALWIREVENUE"
Net Revenue: “TOTALNETREVENUE"
Gross Revenue per Product: "REVENUE", "GROSSREVENUE"
WI Revenue per Product: “WIREVENUE"
Capital
Gross Capital per product: "CAPITAL", "CAPEX", "GROSSCAPITAL", "GROSSCAPEX", "CAPEXGROUP"
WI Capital per product: "WICAPITAL", "WICAPEX”
Gross Capital by Class: "CAPITALCLASS", "GROSSCAPITALCLASS", "CAPEXCLASS", "GROSSCAPEXCLASS"
WI Capital by Class: "WICAPITALCLASS", "WICAPEXCLASS"
Gross Capital Depreciation Pool per Class: "TOTALCAPITALDEPRPOOL", "TOTALGROSSCAPITALDEPRPOOL"
WI Capital Depreciation Pool per Class: "TOTALWICAPITALDEPRPOOL"
Gross Undepreciated Capital: "TOTALUNDEPRCAPITAL", "TOTALGROSSUNDEPRCAPITAL"
WI Undepreciated Capital: "TOTALWIUNDEPRCAPITAL"
Gross Capital Depreciation per Class: "TOTALCAPITALDEPR", "TOTALGROSSCAPITALDEPR"
WI Capital Depreciation per Class: "TOTALWICAPITALDEPR"
Gross Capital Depreciation Used: "TOTALCAPITALUSED", "TOTALGROSSCAPITALUSED"
WI Capital Depreciation Used: "TOTALWICAPITALUSED"
Gross Capital Tax Benefit: "TOTALCAPITALTAXBENEFIT", "TOTALGROSSCAPITALTAXBENEFIT"
WI Capital Tax Benefit: "TOTALWICAPITALTAXBENEFIT"
Gross Capital: "TOTALCAPITAL", "TOTALGROSSCAPITAL"
WI Capital: "TOTALWICAPITAL"
Operating Cost
Gross Operating Cost: "TOTALOPCOST", "TOTALGROSSOPCOST", "TOTALOPCOSTS", "TOTALGROSSOPCOSTS"
WI Operating Cost: "TOTALWIOPCOST", "TOTALWIOPCOSTS"
Gross Fixed Operating Cost: "TOTALFIXEDOPCOST", "TOTALGROSSFIXEDOPCOST", "TOTALFIXEDOPCOSTS", "TOTALGROSSFIXEDOPCOSTS"
WI Fixed Operating Cost: "TOTALWIFIXEDOPCOST", "TOTALWIFIXEDOPCOSTS"
Gross Operating Cost per Product or Class: "OPCOST", "OPCOSTS", "OPEX", "GROSSOPCOST", "GROSSOPEX", "OPEXGROUP"
WI Operating Cost per Product or Class: "WIOPCOST", "WIOPEX"
Gross Fixed Operating Cost per Product or Class: "OPCOSTFIXED", "OPEXFIXED", "GROSSOPCOSTFIXED", "GROSSOPEXFIXED", "OPEXGROUPFIXED"
WI Fixed Operating Cost per Product or Class: "WIOPCOSTFIXED", "WIOPEXFIXED"
Gross Variable Operating Cost per Product or Class: "OPCOSTVARIABLE", "OPEXVARIABLE", "GROSSOPCOSTVARIABLE", "GROSSOPEXVARIABLE", "OPEXGROUPVARIABLE"
WI Variable Operating Cost per Product or Class: "WIOPCOSTVARIABLE", "WIOPEXVARIABLE",
Royalties
Gross Ad Valorum: "STATEADVALORUM", "GROSSSTATEADVALORUM"
WI Ad Valorum: "WISTATEADVALORUM"
Gross Severance: "STATESEVERANCE", "GROSSSTATESEVERANCE"
WI Severance: "WISTATESEVERANCE"
Gross Royalties: "TOTALROYALTIES", "TOTALGROSSROYALTIES", "TOTALBURDENS", "TOTALGROSSBURDENS"
WI Royalties: "TOTALWIROYALTIES", "TOTALWIBURDENS"
Gross Royalties per Product: "ROYALTIES", "BURDENS", "GROSSROYALTIES", "GROSSBURDENS"
WI Royalties per Product: "WIROYALTIES", "WIBURDENS"
Gross Other Royalties: "TOTALOTHERROYALTIES", "TOTALGROSSOTHERROYALTIES"
WI Other Royalties: "TOTALWIOTHERROYALTIES"
Other
Gross Other Income: "TOTALOTHERINCOME", "TOTALGROSSOTHERINCOME"
WI Other Income: "TOTALWIOTHERINCOME"
Gross Overhead: "TOTALOVERHEAD", "TOTALGROSSOVERHEAD"
WI Overhead: "TOTALWIOVERHEAD"
Gross Overhead per Product: "OVERHEAD", "GROSSOVERHEAD"
WI Overhead per Product: “WIOVERHEAD”
Gross Process Cost: "TOTALPROCESS", "TOTALGROSSPROCESS"
WI Process Cost: "TOTALWIPROCESS"
Gross Process Cost per Product: "PROCESS", "GROSSPROCESS"
WI Process Cost per Product: "WIPROCESS"
Economics
Gross Operating Income: "TOTALOPINCOME", "OPERATINGINCOME", "TOTALGROSSOPINCOME", "GROSSOPERATINGINCOME"
WI Operating Income: "TOTALWIOPINCOME", "WIOPERATINGINCOME"
Gross Before Tax Cashflow: "BTCASH", "GROSSBTCASH"
WI Before Tax Cashflow: WIBTCASH"
Gross After Tax Cashflow: "ATCASH", "GROSSATCASH"
WI After Tax Cashflow: "WIATCASH"
Tax
Gross Taxable Income: "TOTALTAXABLEINCOME", "TAXABLEINCOME", "TOTALGROSSTAXABLEINCOME", "GROSSTAXABLEINCOME"
WI Taxable Income: "TOTALWITAXABLEINCOME", "WITAXABLEINCOME"
Gross Tax: "TOTALTAX", "TAXCURRENT", "TOTALGROSSTAX", "GROSSTAXCURRENT"
WI Tax: "TOTALWITAX", "WITAXCURRENT"
Gross Federal Tax: "FEDERALTAX", "GROSSFEDERALTAX"
WI Federal Tax: "WIFEDERALTAX"
Gross State Tax: "STATETAX", "GROSSSTATETAX"
WI State Tax: "WISTATETAX"
Gross Tax Loss Carry Forward: "TOTALTAXLOSSCARRYFORWARD", "TOTALGROSSTAXLOSSCARRYFORWARD"
WI Tax Loss Carry Forward: "TOTALWITAXLOSSCARRYFORWARD"
Production
Gross As Sold Production per Product: "ASSOLDPRODUCTION", "GROSSASSOLDPRODUCTION"
WI As Sold Production per Product: "WIASSOLDPRODUCTION"
Net As Sold Production per Product: "NETASSOLDPRODUCTION"
Gross As Produced Production per Product: "PRODUCTION", "GROSSPRODUCTION"
WI As Produced Production per Product: "WIPRODUCTION"
Net As Produced Production per Product: "NETPRODUCTION", "PRODUCTIONNETROYALTY"
Gross Inflow Potential (Raw) per Product: "INFLOWPOTENTIALRAW", "GROSSINFLOWPOTENTIALRAW", "INFLOWPOTENTIAL", "GROSSINFLOWPOTENTIAL"
WI Inflow Potential (Raw) per Product: "WIINFLOWPOTENTIALRAW", "WIINFLOWPOTENTIAL"
Gross Inflow Potential (Shrunk) per Product: "INFLOWPOTENTIALSHRUNK", "GROSSINFLOWPOTENTIALSHRUNK"
WI Inflow Potential (Shrunk) per Product: "WIINFLOWPOTENTIALSHRUNK"
Gross Outflow Potential per Product: "OUTFLOWPOTENTIAL", "GROSSOUTFLOWPOTENTIAL"
WI Outflow Potential per Product: "WIOUTFLOWPOTENTIAL"
Gross BOE (fluid units): "TOTALBOE", "PRODUCTIONEQUIVALENCE", "TOTALGROSSBOE", "GROSSPRODUCTIONEQUIVALENCE"
WI BOE (fluid units): "TOTALWIBOE", "WIPRODUCTIONEQUIVALENCE"
Effective Shrinkage: “EFFECTIVESHRINKAGE”
Energy Total (energy units): "HEATINGVALUETOTAL"
Heating Value (heating value units): "HEATINGVALUE"
Oil Quality (API Units): "OILQUALITY"
Customs
Custom per Number: “CUSTOM1”, ”CUSTOM2”, “CUSTOM3”, “CUSTOM4”, … , “CUSTOM20”
Ownership
Working Interest: “WI”
Net Revenue Interest: "NRI"
Fixed
Well Count Producing: "WELLCOUNTPRODUCING"
Well Count: "WELLCOUNT"